CWSerenade Environment Configuration

Purpose: This topic describes the setup required to configure a database connection for CWSerenade.

DBConfig Properties File

Use the dbconfig.properties file on the CWSerenade application server to configure database connection settings for CWSerenade. This file contains the database information required to connect to each CWSerenade database. You also define database information in the tomee.xml File.

When to update this file: The system updates this file automatically during the installation process. You will need to update this file and check the settings in the tomee.xml File if you change your database server, database name, or database login; otherwise, the information in this file should not be changed.

Location of file: This file is normally saved on the CWSerenade application server at C:\Serenade\server\conf\jenasysproperties\dbconfig.properties, where C: is the root drive of the CWSerenade application server.

To edit the file: You can review and update this file using a text editor. If you make any changes to the DBConfig Properties file, you must restart the SERENADE service (or the application server) before the changes take effect.

The settings in this file that you might wish to review or edit are explained below.

Setting	Description
environment	The name of the CWSerenade database environment. The delivered setting is CWSerenade Delivered Database. Change this setting to the name of your CWSerenade environment.
db.machine.name	The name of the database server where the CWSerenade database is located.
db.url	The connection information used to connect to the CWSerenade database: 1.db.url = jdbc:sqlserver://SERVERNAME:1433; DatabaseName=CWSerenade;selectMethod=direct;sendStringParametersAsUnicode=false where: • SERVERNAME = The name or IP address of the database server. • 1433 = The port used to connect to the database server. • CWSerenade = The name of the CWSerenade database.
db.user.name	The user ID used to connect to the CWSerenade database server. This should be cwi.
db.password	The user’s SQL Server password used to connect to the CWSerenade database server. The password entry here is encrypted. If you change the SQL Server password as part of your PCI standards, you must change this value and then restart CWSerenade. See Changing the Database Password in the PDF version of the CWSerenade Configuration and Operations Guide for instructions.